private static void newRecord(int num, Int64 number) { zarinReport.closeAllRcord(num); string type = ""; if (num == 1 || num == 2) { type = "ghabl"; } else { type = "bad"; } string sql = "insert into zarin_report_counter" + " (status , intTimeStart , intTimeEnd, timeStart, timeEnd , datep , yearp , monthp , dayp , number , zarin_product , brand , vazn , baste_bandi , darb , counter_num )" + " values " + " ('counts' , '" + PublicMehotd.time_php() + "' , '0' , '" + PublicMehotd.RetStringLocalTime() + "' , '00:00:00' , '" + PublicMehotd.RetStringPersianCalender() + "' , '" + PublicMehotd.retStringYearPersian() + "' , '" + PublicMehotd.retStringMonthPersian() + "' , '" + PublicMehotd.retStringDayPersian() + "' , '" + number.ToString() + "' , '" + ClassEnumProduct.getProductZarinNumber(Convert.ToInt64(Varibale.zarin["zarin_product_" + type])) + "' , '" + Varibale.zarin["brand_" + type] + "' , '" + Varibale.zarin["vazn_" + type] + "' , '" + Varibale.zarin["baste_bandi_" + type] + "' , '" + Varibale.zarin["darb_" + type] + "' , '" + num.ToString() + "')"; SqlConnection cn = ConnectToDatabase.NewConnectToDatabase(); SqlCommand cmd = ConnectToDatabase.NewSqlCommand(CommandType.Text, sql, cn); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
private static string[] getLastDataCounter(int num) { string type = ""; if (num == 1 || num == 2) { type = "ghabl"; } else { type = "bad"; } string zarin_product = ClassEnumProduct.getProductZarinNumber(Convert.ToInt64(Varibale.zarin["zarin_product_" + type])).ToString(); string sql = "select * from zarin_report_counter where counter_num ='" + num + "' and status = 'counts' " + " and zarin_product = '" + zarin_product + "' and brand = '" + Varibale.zarin["brand_" + type] + "' and vazn = '" + Varibale.zarin["vazn_" + type] + "' and darb = '" + Varibale.zarin["darb_" + type] + "' and baste_bandi = '" + Varibale.zarin["baste_bandi_" + type] + "' "; try { string[] x = new string[10]; SqlConnection cn = ConnectToDatabase.NewConnectToDatabase(); SqlCommand cmd = ConnectToDatabase.NewSqlCommand(CommandType.Text, sql, cn); cn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { x[0] = dr["id"].ToString(); x[1] = dr["counter_num"].ToString(); x[2] = dr["number"].ToString(); x[3] = dr["zarin_product"].ToString(); x[4] = dr["brand"].ToString(); x[5] = dr["darb"].ToString(); x[6] = dr["vazn"].ToString(); x[7] = dr["baste_bandi"].ToString(); // if (PublicMehotd.RetStringPersianCalender() == dr["datep"].ToString()) // { cn.Close(); return(x); // } //else //{ // cn.Close(); // return null; // } } else { cn.Close(); return(null); } } catch (Exception ex) { log_system.saveLogSystem(ex, "error get last data counter " + sql + " XX " + zarin_product); return(null); } }