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);
}
