public string Register(RegisterInfo info) { string error = string.Empty; LibDataAccess dataAccess = new LibDataAccess(); string userId = LibSysUtils.ToString(dataAccess.ExecuteScalar(string.Format("select USERID from AXPUSER where USERID={0}", LibStringBuilder.GetQuotString(info.inputId)))); if (string.IsNullOrEmpty(userId)) { string personId = LibSysUtils.ToString(dataAccess.ExecuteScalar(string.Format("select PERSONID from COMPERSON where PERSONNAME={0} and DEPTID={1}", LibStringBuilder.GetQuotString(info.inputName), LibStringBuilder.GetQuotString(info.inputDept)))); //如果遇到同部门同名的情况。建议客户手动创建人员主数据。 if (string.IsNullOrEmpty(personId)) { LibBcfData bcfData = (LibBcfData)LibBcfSystem.Default.GetBcfInstance("com.Person"); DataSet dataSet = bcfData.AddNew(null); DataRow masterRow = dataSet.Tables[0].Rows[0]; masterRow.BeginEdit(); try { if (string.IsNullOrEmpty(LibSysUtils.ToString(masterRow["PERSONID"]))) { masterRow["PERSONID"] = personId = LibCommUtils.GetInternalId().ToString(); } masterRow["PERSONNAME"] = info.inputName; masterRow["GENDER"] = info.gender; masterRow["DEPTID"] = info.inputDept; masterRow["MAIL"] = info.inputEmail; masterRow["PHONENO"] = info.inputPhone; } finally { masterRow.EndEdit(); } dataSet = bcfData.InnerSave(BillAction.AddNew, new object[] { personId }, dataSet); personId = LibSysUtils.ToString(dataSet.Tables[0].Rows[0]["PERSONID"]); } if (!string.IsNullOrEmpty(personId)) { string sql = string.Format("insert into AXPUSER(USERID,USERPASSWORD,PERSONID,ISUSE) values({0},{1},{2},0)", LibStringBuilder.GetQuotString(info.inputId), LibStringBuilder.GetQuotString(info.inputPassword1), LibStringBuilder.GetQuotString(personId)); dataAccess.ExecuteNonQuery(sql); } } else { error = "账号已注册"; } return(error); }
public void UpdateAttachStruct(LibAttachData attachData, List <string> listSql) { if (string.IsNullOrEmpty(attachData.AttachSrc)) { attachData.AttachSrc = LibCommUtils.GetInternalId().ToString(); StringBuilder builder = new StringBuilder(); foreach (var item in attachData.PkList) { if (item.Value.GetType() == typeof(string)) { builder.AppendFormat("{0} = {1} and ", item.Key, LibStringBuilder.GetQuotObject(item.Value)); } else { builder.AppendFormat("{0} = {1} and ", item.Key, item.Value); } } if (builder.Length > 0) { builder.Remove(builder.Length - 4, 4); } //更新单据附件关联字段 listSql.Add(string.Format("update {0} set ATTACHMENTSRC='{1}' where {2}", attachData.TableName, attachData.AttachSrc, builder.ToString())); } foreach (var item in attachData.AttachList) { switch (item.Status) { case LibAttachStatus.Add: listSql.Add(string.Format("insert into AXPATTACHMENTRECORD(BELONGTOID,ORDERID,ORDERNUM,ATTACHMENTNAME,CANUSE) values('{0}',{1},{2},'{3}',1)", attachData.AttachSrc, item.OrderId, item.OrderNum, item.AttachmentName)); break; case LibAttachStatus.Modif: listSql.Add(string.Format("update AXPATTACHMENTRECORD set ORDERNUM={2},ATTACHMENTNAME='{3}' where BELONGTOID='{0}' and ORDERID={1}", attachData.AttachSrc, item.OrderId, item.OrderNum, item.AttachmentName)); break; case LibAttachStatus.Delete: listSql.Add(string.Format("update AXPATTACHMENTRECORD set CANUSE=0 where BELONGTOID='{0}' and ORDERID={1}", attachData.AttachSrc, item.OrderId)); break; } } }
public UpLoadFileResult UpLoadUserPicture(Stream stream) { string dirPath = Path.Combine(EnvProvider.Default.RuningPath, "UserPicture"); return(UpLoadPicture(stream, dirPath, LibCommUtils.GetInternalId().ToString())); }
public override string GetMailBody(LibMailParam param, Dictionary <string, string[]> addressDic) { string html = string.Empty; string path = Path.Combine(EnvProvider.Default.MainPath, "Resource", "MailTpl", "ApproveMailTpl.html"); using (FileStream fs = new FileStream(path, FileMode.Open)) { using (StreamReader reader = new StreamReader(fs, Encoding.Default)) { html = reader.ReadToEnd(); } } html.Replace("@BILL", param.ProgName); html.Replace("@USER", addressDic[param.UserId][0]); html.Replace("@DATE", DateTime.Now.ToShortDateString()); html.Replace("@TEXT", param.Content); if (param.ExpandData.ContainsKey("@IMG")) { string base64 = param.ExpandData["@IMG"]; string imageName = string.Format("{0}-{1}.png", LibDateUtils.GetCurrentDateTime(), LibCommUtils.GetInternalId()); string imgUrl = Path.Combine(".", "PublicData", "Mail", "Image", imageName); using (FileStream fs = new FileStream(imgUrl, FileMode.Create)) { byte[] imageBytes = Convert.FromBase64String(base64); fs.Write(imageBytes, 0, imageBytes.Length); } html.Replace("@IMG", imgUrl); } html.Replace("@LINK", ""); return(html); }