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