public override void AfterSave(Sage.CRM.Controls.EntryGroup screen)
{
Record Rec = screen.getRecord;
screen.Fill(Rec);
Rec.SaveChanges();
string startdate = Rec.GetFieldAsDateTime("mopl_startdate").ToString("yyyy-MM-dd");
string userid = Rec.GetFieldAsString("mopl_userid");
QuerySelect qs = this.GetQuery();
qs.SQLCommand = "select user_LastName from Users where user_userid=" + userid;
qs.ExecuteReader();
string username = qs.FieldValue("user_LastName");
string name = username + "/" + startdate;
qs.SQLCommand = "Update MonthPlan set mopl_Name ='" + name + "' where mopl_MonthPlanid =" + Rec.RecordId.ToString();
qs.ExecuteNonQuery();
base.AfterSave(screen);
}
public override void AfterSave(Sage.CRM.Controls.EntryGroup screen)
{
Record order = screen.getRecord;
QuerySelect s = new QuerySelect();
string prefix = "M" + DateTime.Now.ToString("yyyyMMdd");
s.SQLCommand = "select count(*) as count from MarketInfo where maif_name like '" + prefix + "%'";
s.ExecuteReader();
int cnt = 0;
if (!s.Eof())
{
cnt = Convert.ToInt32(s.FieldValue("count"));
}
string code = string.Empty;
code = prefix + (cnt + 1).ToString().PadLeft(2, '0');
order.SetField("maif_name", code);
order.SaveChanges();
base.AfterSave(screen);
}
public override void AfterSave(Sage.CRM.Controls.EntryGroup screen)
{
//维修单编码规则 R+年月日+2码流水
Record order = screen.getRecord;
QuerySelect s = new QuerySelect();
string username = CurrentUser.UserName;
string prefix = "R" + DateTime.Now.ToString("yyyyMMDD");
s.SQLCommand = "select count(*) as count from Maintenance where mate_name like '" + prefix + "%'";
s.ExecuteReader();
int cnt = 0;
if (!s.Eof())
{
cnt = Convert.ToInt32(s.FieldValue("count"));
}
string code = string.Empty;
code = prefix + (cnt + 1).ToString().PadLeft(2, '0');
order.SetField("mate_name", code);
order.SaveChanges();
base.AfterSave(screen);
}
public override void AfterSave(Sage.CRM.Controls.EntryGroup screen)
{
base.AfterSave(screen);
}
