public ActionResult EditSimCode(EditSimCodeModels model)
{
if (ModelState.IsValid)
{
var result = SimCodeBLL.EditSimCode(model, base.UserIDForLog);
base.DoLog(OperationTypeEnum.Edit, result, "ID:" + model.ID);
return(Json(result));
}
else
{
return(PartialView("_EditSimCode", model));
}
}
public static SelectResult <EditSimCodeModels> GetSimCodeID(int id)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@id", SqlDbType.Int),
};
paras[0].Value = id;
string sql = @" SELECT a.[ID]
,a.[SimCode]
,a.[CommMode]
,OStr.StrucName AS OwnerStrucName
,a.[OwnerStrucID]
,UStr.StrucName AS UseStrucName
,a.[UseStrucID]
,a.[ServiceProviderID]
,a.[PurchaseDate]
,a.[OpeningDate]
,a.[ExpiryDate]
,a.[Remark]
,a.[Status] FROM dbo.SimCodeList AS a LEFT JOIN Structures AS OStr ON a.OwnerStrucID = OStr.ID
LEFT JOIN Structures AS UStr ON a.UseStrucID = UStr.ID WHERE a.ID=@id";
List <EditSimCodeModels> list = ConvertToList <EditSimCodeModels> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray()));
EditSimCodeModels data = null;
string msg = string.Empty;
if (list == null)
{
msg = PromptInformation.DBError;
}
else if (list.Count == 0)
{
msg = PromptInformation.NotExists;
}
else
{
data = list[0];
}
return(new SelectResult <EditSimCodeModels>()
{
DataResult = data,
Message = msg
});
}
public static OperationResult EditSimCode(EditSimCodeModels model, int EditUserID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@ID", SqlDbType.BigInt),
new SqlParameter("@SimCode", SqlDbType.NVarChar, 13),
new SqlParameter("@CommMode", SqlDbType.TinyInt),
new SqlParameter("@OwnerStrucID", SqlDbType.Int),
new SqlParameter("@UseStrucID", SqlDbType.Int),
new SqlParameter("@ServiceProviderID", SqlDbType.Int),
new SqlParameter("@PurchaseDate", SqlDbType.NVarChar, 50),
new SqlParameter("@OpeningDate", SqlDbType.NVarChar, 50),
new SqlParameter("@ExpiryDate", SqlDbType.NVarChar, 50),
new SqlParameter("@Remark", SqlDbType.NVarChar, 50),
new SqlParameter("@EditUserID", SqlDbType.Int),
new SqlParameter("@EditTime", SqlDbType.DateTime)
};
paras[0].Value = model.ID;
paras[1].Value = model.SimCode.Trim();
paras[2].Value = model.CommMode;
paras[3].Value = model.OwnerStrucID;
paras[4].Value = model.UseStrucID;
paras[5].Value = model.ServiceProviderID;
paras[6].Value = model.PurchaseDate;
paras[7].Value = model.OpeningDate;
paras[8].Value = model.ExpiryDate;
if (string.IsNullOrWhiteSpace(model.Remark))
{
paras[9].Value = DBNull.Value;
}
else
{
paras[9].Value = model.Remark;
}
paras[10].Value = EditUserID;
paras[11].Value = DateTime.Now;
#region SQL
string sql;
sql = @"UPDATE dbo.SimCodeList
SET SimCode=@SimCode,CommMode = @CommMode,OwnerStrucID=@OwnerStrucID,
UseStrucID=@UseStrucID,ServiceProviderID = @ServiceProviderID,PurchaseDate = @PurchaseDate,
OpeningDate = @OpeningDate,ExpiryDate = @ExpiryDate,Remark=@Remark,EditUserID=@EditUserID,EditTime=@EditTime
WHERE ID = @ID";
#endregion
int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray());
string msg = string.Empty;
switch (result)
{
case 1:
msg = PromptInformation.OperationSuccess;
break;
case 0:
msg = PromptInformation.NotExists;
break;
case -1:
msg = PromptInformation.DBError;
break;
}
return(new OperationResult()
{
Success = result > 0,
Message = msg
});
}