private void SetSubmitStatus(EnumSubmitStatus status) { DataRow row = gvPO.GetFocusedDataRow(); if (row != null && row[colStatus.FieldName] != DBNull.Value && ConvertEx.StringToEnum <EnumSubmitStatus>(row[colStatus.FieldName]) != status) { row[colStatus.FieldName] = Enum.GetName(typeof(EnumSubmitStatus), status); FieldPO.SqlUpdateStatus((int)row[colId.FieldName], status); btnSubmit.Enabled = (status == EnumSubmitStatus.Open); } }
private void SetSubmitStatus(EnumSubmitStatus status) { var row = gridView1.GetDataRow(gridView1.FocusedRowHandle); if (row != null && row.GetValue(colSubmitStatus) != DBNull.Value && ConvertEx.StringToEnum <EnumSubmitStatus>(row.GetValueString(colSubmitStatus)) != status) { row.SetValue(colSubmitStatus, GetEnumName(status)); LemHeader.SqlUpdateSubmitStatus(row.GetValue <int>(colId), status); btnSubmit.Enabled = (status == EnumSubmitStatus.Open); } }
public LemHeader(DataRow row) { Id = (int)row["Id"]; MatchId = (int)row["MatchId"]; CompanyId = (int)row["CompanyId"]; LogDate = Convert.ToDateTime(row["LogDate"]); LogStatus = ConvertEx.CharToEnum <EnumLogStatus>(row["LogStatus"]); SubmitStatus = ConvertEx.CharToEnum <EnumSubmitStatus>(row["SubmitStatus"]); ProjectId = (int)row["ProjectId"]; LemNum = Convert.ToString(row["LemNum"]); CreatorId = Convert.ToInt32(row["CreatorId"]); Description = Convert.ToString(row["LEM_Desc"]); ApprovalComments = Convert.ToString(row["ApprovalComments"]); EmailData = ConvertEx.ToNullableObj <byte[]>(row["EmailData"]); }
public FieldPO(DataRow row) { Id = Convert.ToInt32(row["Id"]); MatchId = Convert.ToInt32(row["MatchId"]); CompanyId = Convert.ToInt32(row["CompanyId"]); PODate = Convert.ToDateTime(row["PODate"]); PONum = Convert.ToString(row["PONum"]); SupplierCode = Convert.ToString(row["SupplierCode"]); ProjectId = Convert.ToInt32(row["ProjectId"]); Billable = Convert.ToBoolean(row["Billable"]); POAmount = Convert.ToDecimal(row["POAmount"]); SubmitStatus = ConvertEx.CharToEnum <EnumSubmitStatus>(row["FieldPOStatus"]); CreatorId = Convert.ToInt32(row["CreatorId"]); }
public static void SqlUpdateSubmitStatus(int id, EnumSubmitStatus status) { string sql = $"Update LemHeader set SubmitStatus='{(char)status}' where id={id}"; MobileCommon.ExecuteNonQuery(sql); }
public static void SqlUpdateStatus(int id, EnumSubmitStatus status) { string sql = $"update FieldPO set FieldPOStatus='{(char)status}', SyncStatus='{EnumRecordSyncStatus.NoSubmit}' where Id={id}"; MobileCommon.ExecuteNonQuery(sql); }