/// <summary>
///
/// </summary>
public override void Confirm()
{
List <EntityPromotionPlan> lstRecord = null;
if (this.gvPromotionRecord.SelectedRowsCount > 0)
{
lstRecord = new List <EntityPromotionPlan>();
for (int i = this.gvPromotionRecord.RowCount - 1; i >= 0; i--)
{
if (this.gvPromotionRecord.IsRowSelected(i))
{
EntityDisplayPromotionPlan displayVo = this.gvPromotionRecord.GetRow(i) as EntityDisplayPromotionPlan;
EntityPromotionPlan vo = new EntityPromotionPlan();
vo.id = displayVo.id;
vo.auditState = "2";
lstRecord.Add(vo);
}
}
}
if (lstRecord != null)
{
using (ProxyHms proxy = new ProxyHms())
{
if (proxy.Service.ConfirmPromotionRecord(lstRecord) > 0)
{
DialogBox.Msg("审核成功！");
Init();
}
}
}
}
public override void LoadData()
{
EntityDisplayPromotionPlan plan = GetRowObject();
if (plan.planWay == "短信")
{
frm20404 frmMsg = new frm20404();
frmMsg.ShowDialog();
}
else
{
frmPopup2040201 frm = new frmPopup2040201(plan);
frm.ShowDialog();
}
}
/// <summary>
/// 干预记录
/// </summary>
/// <param name="parms"></param>
/// <returns></returns>
public List <EntityDisplayPromotionPlan> GetPromotionPlanRecords(List <EntityParm> dicParm = null)
{
List <EntityDisplayPromotionPlan> data = null;
string strSub = string.Empty;
SqlHelper svc = new SqlHelper(EnumBiz.onlineDB);
string Sql = string.Empty;
Sql = @"select a.id, a.clientId, b.clientName,
b.clientNo,
b.gender,
b.birthday,
b.company,
b.mobile,
b.gradename,
d.planWay,
e.planContent,
a.planRemind,
a.planDate,
a.planVisitRecord,
dd.planWay as recordWay,
ee.planContent as recordContent,
a.auditState,
a.createDate,
a.createName,
a.executeTime,
o.oper_name,
a.regTimes
from promotionPlan a
left join v_clientinfo b
on a.clientId = b.clientNo and a.regTimes = b.regTimes
left join promotionWayConfig d
on a.planWay = d.id
left join promotionWayConfig dd
on a.recordWay = dd.id
left join promotionContentConfig e
on a.planContent = e.id
left join promotionContentConfig ee
on a.recordContent = ee.id
left join code_operator o
on a.executeUserId = o.oper_code
where a.planState = 1
and b.clientNo is not null " ;
List <IDataParameter> lstParm = new List <IDataParameter>();
if (dicParm != null)
{
foreach (EntityParm po in dicParm)
{
switch (po.key)
{
case "clientNo":
IDataParameter parm = svc.CreateParm();
parm.Value = po.value;
lstParm.Add(parm);
strSub += " and b.clientNo = ?";
break;
default:
break;
}
}
}
Sql += strSub;
Sql += " order by b.clientNo,a.planDate";
DataTable dt = svc.GetDataTable(Sql, lstParm);
if (dt != null && dt.Rows.Count > 0)
{
data = new List <EntityDisplayPromotionPlan>();
EntityDisplayPromotionPlan vo = null;
foreach (DataRow dr in dt.Rows)
{
vo = new EntityDisplayPromotionPlan();
vo.id = dr["id"].ToString();
vo.clientId = dr["clientId"].ToString();
vo.clientName = dr["clientName"].ToString();
vo.clientNo = dr["clientNo"].ToString();
vo.gender = Function.Int(dr["gender"]);
if (vo.gender == 1)
{
vo.sex = "男";
}
if (vo.gender == 2)
{
vo.sex = "女";
}
vo.age = Function.CalcAge(Function.Datetime(dr["birthday"]));
vo.company = dr["company"].ToString();
vo.mobile = dr["mobile"].ToString();
vo.gradeName = dr["gradeName"].ToString();
vo.planWay = dr["planWay"].ToString();
vo.planContent = dr["planContent"].ToString();
vo.recordWay = dr["recordWay"].ToString();
vo.recordContent = dr["recordContent"].ToString();
vo.planRemind = dr["planRemind"].ToString();
vo.planVisitRecord = dr["planVisitRecord"].ToString();
vo.executeUserName = dr["oper_name"].ToString();
vo.planDate = Function.Datetime(dr["planDate"]).ToString("yyyy-MM-dd");
if (dr["executeTime"] != DBNull.Value)
{
vo.executeTime = Function.Datetime(dr["executeTime"]).ToString("yyyy-MM-dd");
}
vo.executeUserName = dr["oper_name"].ToString();
vo.createName = dr["createName"].ToString();
data.Add(vo);
}
}
return(data);
}
public frmPopup2040201(EntityDisplayPromotionPlan _displayPromotionPlan = null)
{
InitializeComponent();
promotionPlan = _displayPromotionPlan;
}
