public List <TypeAndState> DataTableToList(DataTable dt)
{
List <TypeAndState> list = new List <TypeAndState>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
TypeAndState item = new TypeAndState();
if ((dt.Rows[i]["guid"] != null) && (dt.Rows[i]["guid"].ToString() != ""))
{
item.guid = new Guid(dt.Rows[i]["guid"].ToString());
}
if ((dt.Rows[i]["code"] != null) && (dt.Rows[i]["code"].ToString() != ""))
{
item.code = dt.Rows[i]["code"].ToString();
}
if ((dt.Rows[i]["Name"] != null) && (dt.Rows[i]["Name"].ToString() != ""))
{
item.Name = dt.Rows[i]["Name"].ToString();
}
if ((dt.Rows[i]["ParentGuid"] != null) && (dt.Rows[i]["ParentGuid"].ToString() != ""))
{
item.ParentGuid = new Guid(dt.Rows[i]["ParentGuid"].ToString());
}
if ((dt.Rows[i]["Type"] != null) && (dt.Rows[i]["Type"].ToString() != ""))
{
item.Type = new int?(int.Parse(dt.Rows[i]["Type"].ToString()));
}
list.Add(item);
}
}
return(list);
}
private string GetTypeOrStateName(Guid guid)
{
TypeAndStateBll typeAndStateBll = new TypeAndStateBll();
TypeAndState model = typeAndStateBll.GetModel(guid);
return(model.Name);
}
private void InitUpdate()
{
if (!string.IsNullOrEmpty(this.typeId))
{
this.model = new TypeAndState();
this.model = this.TASBLL.GetModel(new Guid(this.typeId));
this.txtName.Text = this.model.Name.ToString();
this.txtCode.Text = this.model.code;
this.txtCode.Enabled = false;
this.HidenTypeNumber.Value = this.model.Type.ToString();
}
}
protected void addBtn_Click(object sender, EventArgs e)
{
if (string.Compare(this.action, "Add", true) == 0)
{
this.model = new TypeAndState();
this.model.guid = default(Guid);
this.model.Name = this.txtName.Text.ToString().Trim();
if (this.HidenTypeNumber.Value.ToString() != "")
{
this.model.Type = new int?(int.Parse(this.HidenTypeNumber.Value.ToString()));
}
else
{
this.model.Type = new int?(int.Parse(this.RadioButtonList1.SelectedValue.ToString()));
}
this.model.code = this.txtCode.Text.ToString().Trim();
this.model.ParentGuid = new Guid(this.hidenPTID.Value.ToString());
try
{
if (this.txtName.Text.ToString().Trim() != "")
{
DataTable list = this.TASBLL.GetList("Name= '" + this.txtName.Text.ToString().Trim() + "'");
if (list != null && list.Rows.Count > 0)
{
base.RegisterScript("top.ui.alert('类型名称已经存在')");
}
else
{
this.TASBLL.Add(this.model);
base.RegisterScript("successed();");
}
}
return;
}
catch (Exception)
{
base.RegisterScript("top.ui.alert('添加失败')");
return;
}
}
this.model = new TypeAndState();
this.model = this.TASBLL.GetModel(new Guid(this.typeId));
this.model.Name = this.txtName.Text.ToString().Trim();
this.model.code = this.txtCode.Text.ToString().Trim();
this.model.Type = new int?(int.Parse(this.HidenTypeNumber.Value.ToString()));
if (this.TASBLL.Update(this.model))
{
base.RegisterScript("successed();");
return;
}
base.RegisterScript("top.ui.alert('更新失败')");
}
public void Add(TypeAndState model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into OA_Vehicle_TypeAndState(");
builder.Append("guid,code,Name,ParentGuid,Type)");
builder.Append(" values (");
builder.Append("@guid,@code,@Name,@ParentGuid,@Type)");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@guid", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@code", SqlDbType.NVarChar, 100), new SqlParameter("@Name", SqlDbType.NVarChar, 100), new SqlParameter("@ParentGuid", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@Type", SqlDbType.Int, 4) };
commandParameters[0].Value = Guid.NewGuid();
commandParameters[1].Value = model.code;
commandParameters[2].Value = model.Name;
commandParameters[3].Value = model.ParentGuid;
commandParameters[4].Value = model.Type;
SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters);
}
private void InitAdd()
{
DateTime now = DateTime.Now;
this.txtCode.Text = now.ToString("yyyyMMdd") + now.Millisecond.ToString();
this.txtCode.Enabled = false;
if (this.priGuid != "")
{
TypeAndState typeAndState = this.TASBLL.GetModel(new Guid(this.priGuid));
string text = string.Empty;
if (typeAndState != null)
{
text = typeAndState.Type.ToString();
this.HidenTypeNumber.Value = text.ToString();
this.hidenPTID.Value = this.priGuid;
return;
}
if (this.priGuid == "00000000-0000-0000-0000-000000000000")
{
List <TypeAndState> modelList = this.TASBLL.GetModelList("ParentGuid='00000000-0000-0000-0000-000000000000'");
if (modelList.Count >= 2)
{
this.txtName.Enabled = true;
this.trr.Visible = false;
this.btnSave.Enabled = true;
}
else
{
this.txtName.Enabled = true;
this.trr.Visible = true;
}
this.RadioButtonList1.Items[0].Selected = true;
for (int i = 0; i < modelList.Count; i++)
{
if (modelList[i].Type == 1)
{
this.RadioButtonList1.Items[0].Selected = true;
}
else
{
this.RadioButtonList1.Items[1].Selected = true;
}
}
}
}
}
public bool Update(TypeAndState model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OA_Vehicle_TypeAndState set ");
builder.Append("code=@code,");
builder.Append("Name=@Name,");
builder.Append("ParentGuid=@ParentGuid,");
builder.Append("Type=@Type");
builder.Append(" where guid=@guid ");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@code", SqlDbType.NVarChar, 100), new SqlParameter("@Name", SqlDbType.NVarChar, 100), new SqlParameter("@ParentGuid", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@Type", SqlDbType.Int, 4), new SqlParameter("@guid", SqlDbType.UniqueIdentifier, 0x10) };
commandParameters[0].Value = model.code;
commandParameters[1].Value = model.Name;
commandParameters[2].Value = model.ParentGuid;
commandParameters[3].Value = model.Type;
commandParameters[4].Value = model.guid;
return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters) > 0);
}
public bool Update(TypeAndState model)
{
return(this.dal.Update(model));
}
public void Add(TypeAndState model)
{
this.dal.Add(model);
}
