/// <summary>
/// 添加自定义联系人
/// </summary>
/// <param name="clinkman">CustomLinkman结构</param>
/// <returns>添加的ID</returns>
public int AddCustomLinkman(CustomLinkman clinkman, int staffid)
{
int result = 0;
UDS.Components.Database data = new UDS.Components.Database();
SqlParameter[] prams =
{
data.MakeInParam("@name", SqlDbType.VarChar, 100, clinkman.Name),
data.MakeInParam("@Gender", SqlDbType.Bit, 1, clinkman.Gender),
data.MakeInParam("@UnitTelephone", SqlDbType.VarChar, 50, clinkman.UnitTelephone),
data.MakeInParam("@Email", SqlDbType.VarChar, 50, clinkman.Email),
data.MakeInParam("@UnitAddress", SqlDbType.VarChar, 200, clinkman.UnitAddress),
data.MakeInParam("@UnitZip", SqlDbType.VarChar, 50, clinkman.UnitZip),
data.MakeInParam("@FamilyAddress", SqlDbType.VarChar, 200, clinkman.FamilyAddress),
data.MakeInParam("@FamilyZip", SqlDbType.VarChar, 50, clinkman.FamilyZip),
data.MakeInParam("@Mobile", SqlDbType.VarChar, 100, clinkman.Mobile),
data.MakeInParam("@FamilyTelephone", SqlDbType.VarChar, 100, clinkman.FamilyTelephone),
data.MakeInParam("@Memo", SqlDbType.VarChar, 1000, clinkman.Memo),
data.MakeInParam("@Staffid", SqlDbType.Int, 4, staffid),
data.MakeInParam("@Age", SqlDbType.VarChar, 50, clinkman.Age)
};
result = data.RunProc("sp_Linkman_AddCustomLinkman", prams);
if (clinkman.Type.IndexOf(',', 0) != -1)
{
string [] arrtype = clinkman.Type.Split(',');
for (int i = 0; i < arrtype.Length; i++)
{
if (arrtype[i].Trim() != "")
{
SqlParameter[] prams1 =
{
data.MakeInParam("@typeid", SqlDbType.Int, 4, arrtype[i]),
data.MakeInParam("@id", SqlDbType.Int, 4, result)
};
data.RunProc("sp_Linkman_AddCustomLinkmanType", prams1);
}
}
}
return(result);
}
/// <summary>
/// 更新自定义联系人分类
/// </summary>
/// <param name="mlinkman"></param>
public void UpdateCustomLinkmanType(CustomLinkman clinkman)
{
UDS.Components.Database data = new UDS.Components.Database();
if (clinkman.Type.IndexOf(',', 0) != -1)
{
string [] arrtype = clinkman.Type.Split(',');
for (int i = 0; i < arrtype.Length; i++)
{
if (arrtype[i].Trim() != "")
{
SqlParameter[] prams1 =
{
data.MakeInParam("@typeid", SqlDbType.Int, 4, arrtype[i]),
data.MakeInParam("@id", SqlDbType.Int, 4, clinkman.ID)
};
data.RunProc("sp_Linkman_AddCustomLinkmanType", prams1);
}
}
}
}
/// <summary>
/// 更新自定义联系人
/// </summary>
/// <param name="mlinkman"></param>
public void UpdateCustomLinkman(CustomLinkman clinkman)
{
UDS.Components.Database data = new UDS.Components.Database();
SqlParameter[] prams =
{
data.MakeInParam("@ID", SqlDbType.Int, 4, clinkman.ID),
data.MakeInParam("@name", SqlDbType.VarChar, 100, clinkman.Name),
data.MakeInParam("@Gender", SqlDbType.Bit, 1, clinkman.Gender),
data.MakeInParam("@UnitTelephone", SqlDbType.VarChar, 50, clinkman.UnitTelephone),
data.MakeInParam("@Email", SqlDbType.VarChar, 50, clinkman.Email),
data.MakeInParam("@UnitAddress", SqlDbType.VarChar, 200, clinkman.UnitAddress),
data.MakeInParam("@UnitZip", SqlDbType.VarChar, 50, clinkman.UnitZip),
data.MakeInParam("@FamilyAddress", SqlDbType.VarChar, 200, clinkman.FamilyAddress),
data.MakeInParam("@FamilyZip", SqlDbType.VarChar, 50, clinkman.FamilyZip),
data.MakeInParam("@Mobile", SqlDbType.VarChar, 100, clinkman.Mobile),
data.MakeInParam("@FamilyTelephone", SqlDbType.VarChar, 100, clinkman.FamilyTelephone),
data.MakeInParam("@Memo", SqlDbType.VarChar, 1000, clinkman.Memo),
data.MakeInParam("@Age", SqlDbType.VarChar, 50, clinkman.Age),
data.MakeInParam("@Type", SqlDbType.VarChar, 200, clinkman.Type)
};
data.RunProc("sp_Linkman_UpdateCustomLinkman", prams);
}
/// <summary>
/// �����Զ�����ϵ�˷���
/// </summary>
/// <param name="mlinkman"></param>
public void UpdateCustomLinkmanType(CustomLinkman clinkman)
{
UDS.Components.Database data = new UDS.Components.Database();
if(clinkman.Type.IndexOf(',',0)!=-1)
{
string [] arrtype = clinkman.Type.Split(',');
for(int i = 0;i<arrtype.Length;i++)
{
if(arrtype[i].Trim()!="")
{
SqlParameter[] prams1 = {
data.MakeInParam("@typeid",SqlDbType.Int,4,arrtype[i]),
data.MakeInParam("@id",SqlDbType.Int,4,clinkman.ID)
};
data.RunProc("sp_Linkman_AddCustomLinkmanType",prams1);
}
}
}
}
/// <summary>
/// �����Զ�����ϵ��
/// </summary>
/// <param name="mlinkman"></param>
public void UpdateCustomLinkman(CustomLinkman clinkman)
{
UDS.Components.Database data = new UDS.Components.Database();
SqlParameter[] prams = {
data.MakeInParam("@ID",SqlDbType.Int,4,clinkman.ID),
data.MakeInParam("@name",SqlDbType.VarChar,100,clinkman.Name),
data.MakeInParam("@Gender",SqlDbType.Bit,1,clinkman.Gender),
data.MakeInParam("@UnitTelephone",SqlDbType.VarChar,50,clinkman.UnitTelephone),
data.MakeInParam("@Email",SqlDbType.VarChar,50,clinkman.Email),
data.MakeInParam("@UnitAddress",SqlDbType.VarChar,200,clinkman.UnitAddress),
data.MakeInParam("@UnitZip",SqlDbType.VarChar,50,clinkman.UnitZip),
data.MakeInParam("@FamilyAddress",SqlDbType.VarChar,200,clinkman.FamilyAddress),
data.MakeInParam("@FamilyZip",SqlDbType.VarChar,50,clinkman.FamilyZip),
data.MakeInParam("@Mobile",SqlDbType.VarChar,100,clinkman.Mobile),
data.MakeInParam("@FamilyTelephone",SqlDbType.VarChar,100,clinkman.FamilyTelephone),
data.MakeInParam("@Memo",SqlDbType.VarChar,1000,clinkman.Memo),
data.MakeInParam("@Age",SqlDbType.VarChar,50,clinkman.Age),
data.MakeInParam("@Type",SqlDbType.VarChar,200,clinkman.Type)
};
data.RunProc("sp_Linkman_UpdateCustomLinkman",prams);
}
/// <summary>
/// ����Զ�����ϵ��
/// </summary>
/// <param name="clinkman">CustomLinkman�ṹ</param>
/// <returns>��ӵ�ID</returns>
public int AddCustomLinkman(CustomLinkman clinkman,int staffid)
{
int result = 0;
UDS.Components.Database data = new UDS.Components.Database();
SqlParameter[] prams = {
data.MakeInParam("@name",SqlDbType.VarChar,100,clinkman.Name),
data.MakeInParam("@Gender",SqlDbType.Bit,1,clinkman.Gender),
data.MakeInParam("@UnitTelephone",SqlDbType.VarChar,50,clinkman.UnitTelephone),
data.MakeInParam("@Email",SqlDbType.VarChar,50,clinkman.Email),
data.MakeInParam("@UnitAddress",SqlDbType.VarChar,200,clinkman.UnitAddress),
data.MakeInParam("@UnitZip",SqlDbType.VarChar,50,clinkman.UnitZip),
data.MakeInParam("@FamilyAddress",SqlDbType.VarChar,200,clinkman.FamilyAddress),
data.MakeInParam("@FamilyZip",SqlDbType.VarChar,50,clinkman.FamilyZip),
data.MakeInParam("@Mobile",SqlDbType.VarChar,100,clinkman.Mobile),
data.MakeInParam("@FamilyTelephone",SqlDbType.VarChar,100,clinkman.FamilyTelephone),
data.MakeInParam("@Memo",SqlDbType.VarChar,1000,clinkman.Memo),
data.MakeInParam("@Staffid",SqlDbType.Int,4,staffid),
data.MakeInParam("@Age",SqlDbType.VarChar,50,clinkman.Age)
};
result = data.RunProc("sp_Linkman_AddCustomLinkman",prams);
if(clinkman.Type.IndexOf(',',0)!=-1)
{
string [] arrtype = clinkman.Type.Split(',');
for(int i = 0;i<arrtype.Length;i++)
{
if(arrtype[i].Trim()!="")
{
SqlParameter[] prams1 = {
data.MakeInParam("@typeid",SqlDbType.Int,4,arrtype[i]),
data.MakeInParam("@id",SqlDbType.Int,4,result)
};
data.RunProc("sp_Linkman_AddCustomLinkmanType",prams1);
}
}
}
return(result);
}
