public string SelPorceLainSerialNum() { int intYear = DateTime.Now.Year; int intMonth = DateTime.Now.Month; int intDate = DateTime.Now.Day; int intHour = DateTime.Now.Hour; int intSecond = DateTime.Now.Second; int intMinute = DateTime.Now.Minute; string strTime = null; strTime += "SP-"; strTime += intYear.ToString(); strTime += intMonth < 10 ? "0" + intMonth.ToString() : intMonth.ToString(); string selnum = "SELECT top 1 RIGHT(PlSerialNum,6) FROM SelPorcelain where LEFT(PlSerialNum,9)='" + strTime + "' order by PlSerialNum desc"; //getSqlConnection getConnection = new getSqlConnection(); conn = Dbconnection.Dblink(); conn.Open(); cmd = new SqlCommand(selnum, conn); int maxNum = 1; string strMaxnum = ""; qlddr = cmd.ExecuteReader(); if (qlddr.Read()) { maxNum = Convert.ToInt32(qlddr.GetString(0)) + 1; } if (maxNum > 0 && maxNum < 10) { strMaxnum = "00000" + maxNum; } else if (maxNum >= 10 && maxNum < 100) { strMaxnum = "0000" + maxNum; } else if (maxNum >= 100 && maxNum < 1000) { strMaxnum = "000" + maxNum; } else if (maxNum >= 1000 && maxNum < 10000) { strMaxnum = "00" + maxNum; } else if (maxNum >= 10000 && maxNum < 100000) { strMaxnum = "0" + maxNum; } else { strMaxnum = Convert.ToString(maxNum); } qlddr.Close(); return(strTime + strMaxnum); }
}// end if #endregion static Boolean isGm(string _id) { Boolean result = false; Dbconnection db = new Dbconnection(); string sql = "select empfalg from tb_empinfo where empid='" + _id + "'"; if (db.ExeInfochange(sql) != 0) { result = true; } return(result); }
public int WareInOutFind(string strObject, string pwwd, int intFalg) { int intCount = 0; string strSecar = null; try { switch (intFalg) { case 1: strSecar = "select * from tb_EmpInfo where EmpLoginName= '" + strObject + "' and EmpFalg=0"; break; case 2: strSecar = "select * from tb_EmpInfo where EmpLoginName= '" + strObject + "' and EmpFalg=0 and EmpLoginPwd='" + pwwd + "'"; break; } conn = Dbconnection.Dblink(); conn.Open(); cmd = new SqlCommand(strSecar, conn); qlddr = cmd.ExecuteReader(); qlddr.Read(); if (qlddr.HasRows) { intCount = 1; } return(intCount); } catch (Exception ee) { MessageBox.Show(ee.Message.ToString()); return(intCount = 2); } }
public string WareInOutSerialNum(int _FTYPE) { int intYear = DateTime.Now.Year; int intMonth = DateTime.Now.Month; int intDate = DateTime.Now.Day; int intHour = DateTime.Now.Hour; int intSecond = DateTime.Now.Second; int intMinute = DateTime.Now.Minute; string strTime = null; if (_FTYPE == 0) { strTime += "RK-"; } else { strTime += "CK-"; } strTime += intYear.ToString(); string selnum = "SELECT top 1 RIGHT(FSerialNum,6) FROM WareInOut where FTYPE = " + _FTYPE + " AND LEFT(FSerialNum,7)='" + strTime + "' order by FSerialNum desc"; //getSqlConnection getConnection = new getSqlConnection(); conn = Dbconnection.Dblink(); conn.Open(); cmd = new SqlCommand(selnum, conn); int maxNum = 1; string strMaxnum = ""; qlddr = cmd.ExecuteReader(); if (qlddr.Read()) { maxNum = Convert.ToInt32(qlddr.GetString(0)) + 1; } if (maxNum > 0 && maxNum < 10) { strMaxnum = "00000" + maxNum; } else if (maxNum >= 10 && maxNum < 100) { strMaxnum = "0000" + maxNum; } else if (maxNum >= 100 && maxNum < 1000) { strMaxnum = "000" + maxNum; } else if (maxNum >= 1000 && maxNum < 10000) { strMaxnum = "00" + maxNum; } else if (maxNum >= 10000 && maxNum < 100000) { strMaxnum = "0" + maxNum; } else { strMaxnum = Convert.ToString(maxNum); } qlddr.Close(); /* if (intHour < 10) * { * strTime += "0" + intHour.ToString(); * } * else * { * strTime += intHour.ToString(); * } * if (intMinute < 10) * { * * strTime += "0" + intMinute.ToString(); * } * else * { * strTime += intMinute.ToString(); * } * if (intSecond < 10) * { * * strTime += "0" + intSecond.ToString(); * } * else * { * strTime += intSecond.ToString(); * } */ return(strTime + strMaxnum); }