/// <summary>
/// 修改管理员，特别注意：密码
/// </summary>
/// <param name="mi"></param>
/// <returns></returns>
public int Update(CicData mi)
{
//为什么要进行密码的判断：
//答：因为密码值是经过md5加密存储的，当修改时，需要判断用户是否改了密码，如果没有改，则不变，如果改了，则重新进行md5加密
//定义参数集合，可以动态添加元素
List <OleDbParameter> listPs = new List <OleDbParameter>();
//构造update的sql语句
string sql = "update bg_customs_state set electronic_declaration=@p1, electronic_declaration_time=@p2, computer_review=@p3, computer_review_time=@p4, scene_receipt=@p5, scene_receipt_time=@p6, documentary_release=@p7, documentary_release_time=@p8";
//listPs.Add(new OleDbParameter("@p1", mi.electronicDeclaration));
//listPs.Add(new OleDbParameter("@p2", mi.electronicDeclarationTime));
//listPs.Add(new OleDbParameter("@p3", mi.computerReview));
//listPs.Add(new OleDbParameter("@p4", mi.computerReviewTime));
//listPs.Add(new OleDbParameter("@p5", mi.sceneReceipt));
//listPs.Add(new OleDbParameter("@p6", mi.sceneReceiptTime));
//listPs.Add(new OleDbParameter("@p7", mi.documentaryRelease));
//listPs.Add(new OleDbParameter("@p8", mi.documentaryReleaseTime));
//继续拼接语句
sql += ",release_of_goods=@p9 ,release_of_goods_time =@p10 ,update_date=@p11 ,create_date =@p12 where bg_no=@id";
//listPs.Add(new OleDbParameter("@p9", mi.releaseOfGoods));
//listPs.Add(new OleDbParameter("@p10", mi.releaseOfGoodsTime));
//listPs.Add(new OleDbParameter("@p11", mi.utime));
//listPs.Add(new OleDbParameter("@p12", mi.ctime));
//listPs.Add(new OleDbParameter("@id", mi.bgNo));
//执行语句并返回结果
return(accessHelper.ExcuteNonQuery(sql, listPs.ToArray()));
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="mi">ManagerInfo类型的对象</param>
/// <returns></returns>
public int Insert(CicData mi)
{
//构造insert语句
string sql = "insert into bg_customs_state(bg_no,electronic_declaration,electronic_declaration_time,computer_review,computer_review_time,scene_receipt,scene_receipt_time,documentary_release,documentary_release_time,release_of_goods,release_of_goods_time,update_date,create_date)";
sql += " values(@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13)";
//构造sql语句的参数
OleDbParameter[] ps = //使用数组初始化器
{
//new OleDbParameter("@p1", mi.bgNo),
//new OleDbParameter("@p2", mi.electronicDeclaration ),
//new OleDbParameter("@p3", mi.electronicDeclarationTime),
//new OleDbParameter("@p4", mi.computerReview),
//new OleDbParameter("@p5", mi.computerReviewTime ),
//new OleDbParameter("@p6", mi.sceneReceipt),
//new OleDbParameter("@p7", mi.sceneReceiptTime ),
//new OleDbParameter("@p8", mi.documentaryRelease),
//new OleDbParameter("@p9", mi.documentaryReleaseTime ),
//new OleDbParameter("@p10", mi.releaseOfGoods),
//new OleDbParameter("@p11", mi.releaseOfGoodsTime ),
//new OleDbParameter("@p12", mi.utime),
//new OleDbParameter("@p13", mi.ctime )
};
//执行插入操作
return(accessHelper.ExcuteNonQuery(sql, ps));
}
public bool Edit(CicData mi)
{
return(miDal.Update(mi) > 0);
}
public bool Add(CicData mi)
{
//调用dal层的insert方法，完成插入操作
return(miDal.Insert(mi) > 0);
}
