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); } }