{
if (!EntryInDgv)
{
SwitchMode(2);
EntryInDgv = true;
}
row = ((DataRowView)dgvInDocs.Rows[e.RowIndex].DataBoundItem).Row;
tblRowIndex = Array.IndexOf(tblInDocs.Select(), row);
cboDept.SelectedValue = row["DeptID"].ToString();
cboDept.Text = row["Dept"].ToString();
cboInDocType.SelectedValue = row["InDocTypesID"].ToString();
cboInDocType.Text = row["DocType"].ToString();
tbNum.Text = row["Num"].ToString();
dtpDate.Value = Convert.ToDateTime(row["Date"]);
dtpInDate.Value = Convert.ToDateTime(row["InDate"]);
tbDescription.Text = row["Description"].ToString();
lblImgFile.Text = row["ImgFile"].ToString();
currentConstID = (int)row["ConstID"];
}//обновление связанных с текущей строкой конролов
public static bool SaveChanges(DateTime Date, DateTime InDate,
int ConstID = 0,
int InDocTypeID = 0,
string Num ="",
int DeptID = 0,
string Description = "",
string ImgFile ="",
byte[] Img = null,
int rowStatus = 0)
{
SqlConnection cn = new
SqlConnection(SessionProperties.currentConnectionString);
SqlCommand cmd = new SqlCommand("dbo.EditInDocs", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add("@ConstID", SqlDbType.Int);
cmd.Parameters["@ConstID"].Value = ConstID;
cmd.Parameters.Add("@InDocTypesID", SqlDbType.Int);
cmd.Parameters["@InDocTypesID"].Value = InDocTypeID;
cmd.Parameters.Add("@Num", SqlDbType.NVarChar, 20);
cmd.Parameters["@Num"].Value = Num;
cmd.Parameters.Add("@Date", SqlDbType.DateTime);
cmd.Parameters["@Date"].Value = Date;
cmd.Parameters.Add("@DeptID", SqlDbType.Int);
cmd.Parameters["@DeptID"].Value = DeptID;
cmd.Parameters.Add("@InDate", SqlDbType.DateTime);
cmd.Parameters["@InDate"].Value = InDate;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar, 254);
cmd.Parameters["@Description"].Value = Description;
cmd.Parameters.Add("@ImgFile", SqlDbType.NVarChar, 254);
cmd.Parameters["@ImgFile"].Value = ImgFile;
cmd.Parameters.Add("@Img", SqlDbType.Image);
cmd.Parameters["@Img"].Value = Img;
cmd.Parameters.Add("@SessionsID", SqlDbType.Int);
cmd.Parameters["@SessionsID"].Value = SessionProperties.sessionID;