private void frmVerificationDoc_Load(object sender, EventArgs e) { if (id > -1) { inv = new Verification(id); closed = true; DataTable t = new DataTable("i"); t.Columns.Add("no", Type.GetType("System.String")); t.Columns.Add("found", Type.GetType("System.Boolean")); t.Columns.Add("status_t", Type.GetType("System.String")); t.Columns.Add("status_fact_t", Type.GetType("System.String")); t.Columns.Add("in", Type.GetType("System.DateTime")); t.Columns.Add("out", Type.GetType("System.DateTime")); t.Columns.Add("action_t", Type.GetType("System.String")); t.Columns.Add("status", Type.GetType("System.String")); t.Columns.Add("status_fact", Type.GetType("System.String")); t.Columns.Add("show", Type.GetType("System.Boolean")); t.Columns.Add("action", Type.GetType("System.String")); t.Columns.Add("user", Type.GetType("System.Int32")); t.Columns.Add("exported", Type.GetType("System.Boolean")); for (int i = 0; i < inv.body.Count; i++) { if (inv.body[i].date_in.Year > 1901) { t.Rows.Add(new object[13] { inv.body[i].number, inv.body[i].found, inv.body[i].status_t, inv.body[i].status_fact_t, inv.body[i].date_in, inv.body[i].date_out, inv.body[i].action, inv.body[i].status, inv.body[i].status_fact, true, inv.body[i].action_t, inv.body[i].usr.Id_user, inv.body[i].exported } ); } else { t.Rows.Add(new object[13] { inv.body[i].number, inv.body[i].found, inv.body[i].status_t, inv.body[i].status_fact_t, null, null, inv.body[i].action, inv.body[i].status, inv.body[i].status_fact, true, inv.body[i].action_t, inv.body[i].usr.Id_user, inv.body[i].exported } ); } } orders = t; updateTable(); this.Title = "Документ сверки № " + inv.id.ToString("D6"); } LoadStatus(); if (id > -1) btnApply_Click(this, new EventArgs()); CheckStatus(); }
public static List<Verification> getList() { List<Verification> lst = new List<Verification>(); try { VerificationProvider pr = new VerificationProvider(); DataSet ds = pr.GetList(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Verification o = new Verification(); o.id = int.Parse(ds.Tables[0].Rows[i]["id_verification"].ToString()); o.del = bool.Parse(ds.Tables[0].Rows[i]["del"].ToString()); o.guid = ds.Tables[0].Rows[i]["guid"].ToString(); if (ds.Tables[0].Rows[i]["verification_date"].ToString() != "") o.date = DateTime.Parse(ds.Tables[0].Rows[i]["verification_date"].ToString()); o.usr = new Photoland.Security.User.UserInfo(); o.usr.Id_user = int.Parse(ds.Tables[0].Rows[i]["verification_user"].ToString()); // не правильно, но старые объекты не стал переписывать :) пятница! UserProvider upr = new UserProvider(); o.usr.Name = upr.getNameById(o.usr.Id_user); lst.Add(o); } } catch (Exception ex) { } return lst; }
private void btnCloseInvent_Click(object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(settings.Connection_string)) { con.Open(); SqlCommand cmd = con.CreateCommand(); SqlTransaction transaction = con.BeginTransaction("save"); cmd.Connection = con; cmd.Transaction = transaction; int i; try { lblSave.Visible = true; int verification_id = 0; cmd.CommandText = "INSERT INTO [dbo].[verification]" + "([verification_date]" + ",[verification_user]" + ",[exported])" + "VALUES" + "(getdate()" + "," + usr.Id_user.ToString() + ", 0); SELECT scope_identity();"; verification_id = int.Parse(cmd.ExecuteScalar().ToString()); pb1.Minimum = 1; pb1.Maximum = data.Rows.Count; pb1.Value = pb1.Minimum; for (i = 1; i < data.Rows.Count; i++) { int show; if (bool.Parse(data.Rows[i][2].ToString())) show = 1; else show = 0; if (data.Rows[i][5].ToString() == "") { cmd.CommandText = "INSERT INTO [dbo].[verificationbody]" + "([id_verification]" + ",[order_number]" + ",[order_found]" + ",[order_status_t]" + ",[order_status]" + ",[order_status_fact_t]" + ",[order_status_fact]" + ",[order_action_t]" + ",[order_action]" + ",[order_user]" + ",[exported])" + "VALUES" + "(" + verification_id + ",'" + data.Rows[i][1].ToString() + "'" + "," + show + ",'" + data.Rows[i][3].ToString() + "'" + ",'" + data.Rows[i][8].ToString() + "'" + ",'" + data.Rows[i][4].ToString() + "'" + ",'" + data.Rows[i][9].ToString() + "'" + ",'" + data.Rows[i][7].ToString() + "'" + ",'" + data.Rows[i][11].ToString() + "'" + "," + usr.Id_user.ToString() + "" + "," + data.Rows[i][13].ToString() + ")"; } else { cmd.CommandText = "INSERT INTO [dbo].[verificationbody]" + "([id_verification]" + ",[order_number]" + ",[order_found]" + ",[order_status_t]" + ",[order_status]" + ",[order_status_fact_t]" + ",[order_status_fact]" + ",[order_in]" + ",[order_out]" + ",[order_action_t]" + ",[order_action]" + ",[order_user] " + ",[exported] " + ")" + "VALUES" + "(" + verification_id + ",'" + data.Rows[i][1].ToString() + "'" + "," + show + ",'" + data.Rows[i][3].ToString().Trim() + "'" + ",'" + data.Rows[i][8].ToString().Trim() + "'" + ",'" + data.Rows[i][4].ToString().Trim() + "'" + ",'" + data.Rows[i][9].ToString().Trim() + "'" + ",'" + ((DateTime)data.Rows[i][5]).Year.ToString("D4") + "/" + ((DateTime)data.Rows[i][5]).Month.ToString("D2") + "/" + ((DateTime)data.Rows[i][5]).Day.ToString("D2") + " " + ((DateTime)data.Rows[i][5]).ToShortTimeString() + "'" + ",'" + ((DateTime)data.Rows[i][6]).Year.ToString("D4") + "/" + ((DateTime)data.Rows[i][6]).Month.ToString("D2") + "/" + ((DateTime)data.Rows[i][6]).Day.ToString("D2") + " " + ((DateTime)data.Rows[i][6]).ToShortTimeString() + "'" + ",'" + data.Rows[i][7].ToString() + "'" + ",'" + data.Rows[i][11].ToString() + "'" + "," + usr.Id_user.ToString() + "," + data.Rows[i][13].ToString() + ")"; } cmd.ExecuteNonQuery(); pb1.Value = i; Application.DoEvents(); } transaction.Commit(); inv = new Verification(verification_id); closed = true; CheckStatus(); } catch (Exception ex) { transaction.Rollback(); MessageBox.Show("Произошла ошибка во время сохранения инвентаризации.\n" + ex.Message + "\n" + ex.Source + "\n" + ex.StackTrace, "Ошибка сохранения", MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { lblSave.Visible = false; } } }