public static void SetAutoNum(AutoNum val, SqlConnection cn)
{
SortingClass.CheckColumn("CompetitionData", "AutoNum", "VARCHAR(3) NOT NULL DEFAULT '" + AutoNum.GRP.ToString() + "'", cn);
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = "UPDATE CompetitionData SET AutoNum='" + val.ToString() + "'";
cmd.ExecuteNonQuery();
}
protected override void BeforeSave(Dictionary <string, string> dic, S_UI_Form formInfo, bool isNew)
{
base.BeforeSave(dic, formInfo, isNew);
var id = dic.GetValue("ID");
var isDomestic = dic.GetValue("IsDomestic");
var code = dic.GetValue("SupplierCode");
//验证编号重复
var exist = this.EPCEntites.Set <S_I_SupplierInfo>().FirstOrDefault(a => a.ID != id && a.SupplierCode == code);
//最新编号
if (exist != null)
{
int AutoNum;
var Code = createCode(isDomestic, out AutoNum);
dic.SetValue("SupplierCode", Code);
dic.SetValue("AutoNum", AutoNum.ToString());
}
}
/// <summary>
/// 智能识别
/// </summary>
static void testAutoNum()
{
AutoNum.query("773039762404825", config.key);
}
public static int GetNextNumber(int groupID, SqlConnection cn, SqlTransaction tran, AutoNum aNum, bool isOnl)
{
if (cn.State != ConnectionState.Open)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.Transaction = tran;
string tableName = (isOnl ? "ONLclimbers" : "Participants");
int num;
switch (aNum)
{
case AutoNum.GRP:
cmd.CommandText =
String.Format("SELECT ISNULL(MAX(iid),0) iid FROM {0}(NOLOCK) WHERE group_id = {1}", tableName, groupID);
object oTmp = cmd.ExecuteScalar();
if (oTmp != null && oTmp != DBNull.Value)
{
num = Convert.ToInt32(oTmp);
}
else
{
num = 0;
}
if (num == 0)
{
num = (groupID - 1) * 100 + 1;
}
else if (num % 100 == 99)
{
num = GetNextGrpNum(groupID, num, cn, tran, isOnl);
}
else
{
num++;
}
break;
case AutoNum.ROW:
num = (int)GetNextIID(tableName, "iid", cn, tran);
break;
default:
goto case AutoNum.ROW;
}
while (checkNum(num, tableName, cn, tran))
{
num = (int)GetNextIID(tableName, "iid", cn, tran);
}
return(num);
}
}
