62,041
社区成员
发帖
与我相关
我的任务
分享
public string GetID(string CompanyName,string Dep,string myType)
{
//HH OS CT 0001
StringBuilder No = new StringBuilder();
//公司名
if(CompanyName==string.Empty || CompanyName =="")
{
No.Append("HH");
}
else
{
No.Append(CompanyName.Substring(0,2));
}
//部门缩写
if(Dep==string.Empty || Dep=="")
{
No.Append("AA");
}
else
{
No.Append(Dep.Substring(0,2));
}
//年度
No.Append(DateTime.Now.Year.ToString().Substring(2,2));
//编号
SYSFormMain BLLFormMain = new SYSFormMain();
string id = BLLFormMain.GetID(No.ToString());
No.Append(id);
//类型
if (myType == string.Empty || myType == "")
{
No.Append("A");
}
else
{
No.Append(myType.Substring(0, 1));
}
return No.ToString();
}
/// <summary>
/// 获得当前类型的 最新ID
/// </summary>
/// <param name="FormNo"></param>
/// <returns></returns>
public string GetID(string FormNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,FormName,FormNo,FormClassID,ItemCount,XMMC,XMBH,HTMC,HTBH,FormZT,WTDT,DepartmentID,UserID,ZT,CreateDT from SYSFormMain ");
strSql.Append(" where FormNo like '"+FormNo+"%' order by id desc");
//SqlParameter[] parameters = {
// new SqlParameter("@FormNo", SqlDbType.VarChar,50)};
////parameters[0].Value = ID;
//parameters[0].Value = FormNo.Substring(0, 6);
//HHOAWeb.Model.SYSFormMain model = new HHOAWeb.Model.SYSFormMain();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
string newFormNo;
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["FormNo"].ToString() == "" || ds.Tables[0].Rows[0]["FormNo"].ToString().Length<10)
{
newFormNo = "001";
}
else
{
int ID =int.Parse( ds.Tables[0].Rows[0]["FormNo"].ToString().Substring(6, 3))+1;
newFormNo = ID.ToString().PadLeft(3,'0');
}
}
else
{
newFormNo = "001";
}
return newFormNo;
}
string.Format("{0}{1}{2:yy}{3:000}{4}",公司名缩写,部门名缩写,DateTime.Now,序号,类型)//序号使用数值类型